INSERT INTO pub_bcr_nbcr (
        pk_nbcr,
        code,
        codelenth,
        codescope,
        codestyle,
        comp,
        dr,
        metaid,
        name,
        orgtype,
        ts
)
VALUES
        (
                '0001ZZZZ54C4A3511757',
                'TXDJ',
                40,
                'global',
                'both',
                NULL,
                0,
                '9332225b-8fb3-4ca4-9efd-4e6f2d9564ca',
                '~',
                'FINANCEORGTYPE000000',
                '2021-10-25 00:41:52'
        );

go

INSERT INTO pub_bcr_rulebase (
        pk_billcodebase,
        codemode,
        codescope,
        dataoriginflag,
        dr,
        format,
        isautofill,
        isdefault,
        iseditable,
        isgetpk,
        islenvar,
        isused,
        nbcrcode,
        pk_group,
        rulecode,
        rulename,
        ts
)
VALUES
        (
                '0001ZZZZF443DCC403BF',
                'after',
                'a',
                0,
                0,
                'yyyyMMdd',
                'N',
                'N',
                'N',
                'N',
                'Y',
                'Y',
                'TXDJ',
                'GLOBLE00000000000000',
                'TXDJCODE',
                '~',
                '2021-10-25 00:41:52'
        );

go

INSERT INTO pub_bcr_elem (
        pk_billcodeelem,
        dataoriginflag,
        dr,
        elemlenth,
        elemtype,
        elemvalue,
        eorder,
        fillsign,
        fillstyle,
        isrefer,
        pk_billcodebase,
        pk_billcodeentity,
        ts
)
VALUES
        (
                '0001ZZZZB1474B5D8D69',
                NULL,
                0,
                5,
                0,
                'TXDJ',
                0,
                NULL,
                0,
                0,
                '0001ZZZZF443DCC403BF',
                '~',
                '2021-10-25 00:41:52'
        );
go
INSERT INTO pub_bcr_elem (
        pk_billcodeelem,
        dataoriginflag,
        dr,
        elemlenth,
        elemtype,
        elemvalue,
        eorder,
        fillsign,
        fillstyle,
        isrefer,
        pk_billcodebase,
        pk_billcodeentity,
        ts
)
VALUES
        (
                '0001ZZZZ73AEFA0141EC',
                NULL,
                0,
                8,
                2,
                'billdate',
                1,
                NULL,
                0,
                0,
                '0001ZZZZF443DCC403BF',
                '~',
                '2021-10-25 00:41:52'
        );
go
INSERT INTO pub_bcr_elem (
        pk_billcodeelem,
        dataoriginflag,
        dr,
        elemlenth,
        elemtype,
        elemvalue,
        eorder,
        fillsign,
        fillstyle,
        isrefer,
        pk_billcodebase,
        pk_billcodeentity,
        ts
)
VALUES
        (
                '0001ZZZZA85B66749964',
                NULL,
                0,
                4,
                3,
                null,
                2,
                NULL,
                0,
                0,
                '0001ZZZZF443DCC403BF',
                '~',
                '2021-10-25 00:41:52'
        );
go